insert overwrite table jms_dim.dim_adjust_detail_dt partition(dt)
select
id
,notice_id
,adjust_type
,adjust_nature
,departure_date
,task_no
,stowage_capacity
,car_num
,destination_center
,destination_center_name
,plan_departure_time
,plan_arrival_time
,transfer_flow_direction
,trans_volume
,trans_mileage
,settle_expenses
,plan_arrival_time_stops
,plan_departure_time_stops
,arrival_time_destination_station
,stopover_load
,line_name
,model
,square_number
,opera_mode_before_adjust
,opera_mode_after_adjust
,contact_info
,stowage
,dest_before_adjust
,dest_before_adjust_name
,dest_after_adjust
,dest_after_adjust_name
,is_delete
,reference_trans_path
,trans_path
,flow_network_code
,flow_network_name
,network_code
,network_name
,planned_departure_time
,planned_arrival_time
,handling_type
,handling_type_name
,handling_after_type
,demand_unit_code
,demand_unit_name
,line_mileage
,detour_coefficient
,dt
from jms_ods.adjust_detail
where dt = '{{ execution_date | cst_ds }}'
distribute by 1 ;